IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = N'tmcguinness')
CREATE LOGIN [tmcguinness] WITH PASSWORD = 'p@ssw0rd'
GO
CREATE USER [tmcguinness] FOR LOGIN [tmcguinness]
GO
GRANT ALTER TO [tmcguinness]
GRANT ALTER ANY ASYMMETRIC KEY TO [tmcguinness]
GRANT ALTER ANY APPLICATION ROLE TO [tmcguinness]
GRANT ALTER ANY ASSEMBLY TO [tmcguinness]
GRANT ALTER ANY CERTIFICATE TO [tmcguinness]
GRANT ALTER ANY DATASPACE TO [tmcguinness]
GRANT ALTER ANY DATABASE EVENT NOTIFICATION TO [tmcguinness]
GRANT ALTER ANY FULLTEXT CATALOG TO [tmcguinness]
GRANT ALTER ANY MESSAGE TYPE TO [tmcguinness]
GRANT ALTER ANY ROLE TO [tmcguinness]
GRANT ALTER ANY ROUTE TO [tmcguinness]
GRANT ALTER ANY REMOTE SERVICE BINDING TO [tmcguinness]
GRANT ALTER ANY CONTRACT TO [tmcguinness]
GRANT ALTER ANY SYMMETRIC KEY TO [tmcguinness]
GRANT ALTER ANY SCHEMA TO [tmcguinness]
GRANT ALTER ANY SERVICE TO [tmcguinness]
GRANT ALTER ANY DATABASE DDL TRIGGER TO [tmcguinness]
GRANT ALTER ANY USER TO [tmcguinness]
GRANT AUTHENTICATE TO [tmcguinness]
GRANT BACKUP DATABASE TO [tmcguinness]
GRANT BACKUP LOG TO [tmcguinness]
GRANT CONTROL TO [tmcguinness]
GRANT CONNECT REPLICATION TO [tmcguinness]
GRANT CHECKPOINT TO [tmcguinness]
GRANT CREATE AGGREGATE TO [tmcguinness]
GRANT CREATE ASYMMETRIC KEY TO [tmcguinness]
GRANT CREATE ASSEMBLY TO [tmcguinness]
GRANT CREATE CERTIFICATE TO [tmcguinness]
GRANT CREATE DEFAULT TO [tmcguinness]
GRANT CREATE DATABASE DDL EVENT NOTIFICATION TO [tmcguinness]
GRANT CREATE FUNCTION TO [tmcguinness]
GRANT CREATE FULLTEXT CATALOG TO [tmcguinness]
GRANT CREATE MESSAGE TYPE TO [tmcguinness]
GRANT CREATE PROCEDURE TO [tmcguinness]
GRANT CREATE QUEUE TO [tmcguinness]
GRANT CREATE ROLE TO [tmcguinness]
GRANT CREATE ROUTE TO [tmcguinness]
GRANT CREATE RULE TO [tmcguinness]
GRANT CREATE REMOTE SERVICE BINDING TO [tmcguinness]
GRANT CREATE CONTRACT TO [tmcguinness]
GRANT CREATE SYMMETRIC KEY TO [tmcguinness]
GRANT CREATE SCHEMA TO [tmcguinness]
GRANT CREATE SYNONYM TO [tmcguinness]
GRANT CREATE SERVICE TO [tmcguinness]
GRANT CREATE TABLE TO [tmcguinness]
GRANT CREATE TYPE TO [tmcguinness]
GRANT CREATE VIEW TO [tmcguinness]
GRANT CREATE XML SCHEMA COLLECTION TO [tmcguinness]
GRANT DELETE TO [tmcguinness]
GRANT EXECUTE TO [tmcguinness]
GRANT INSERT TO [tmcguinness]
GRANT REFERENCES TO [tmcguinness]
GRANT SELECT TO [tmcguinness]
GRANT SHOWPLAN TO [tmcguinness]
GRANT SUBSCRIBE QUERY NOTIFICATIONS TO [tmcguinness]
GRANT TAKE OWNERSHIP TO [tmcguinness]
GRANT UPDATE TO [tmcguinness]
GRANT VIEW DEFINITION TO [tmcguinness]
GRANT VIEW DATABASE STATE TO [tmcguinness]
GRANT ALTER ANY DATABASE AUDIT TO [tmcguinness]
